package com.example.mes_boot.mapper;

import com.example.mes_boot.pojo.checkpoint;
import com.example.mes_boot.pojo.factory;
import com.example.mes_boot.pojo.process;
import com.example.mes_boot.pojo.project;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.session.RowBounds;

import java.util.List;

@Mapper
public interface Indexmapper {
    @Select("select*from cf_electric_checkpoint")
    public List<checkpoint> findBypage(RowBounds rowBounds);
    @Select("select*from cf_electric_checkpoint")
    public List<checkpoint> findBy();
    @Select("select*from cf_electric_checkpoint where name like concat('%',#{name},'%') or address like concat('%',#{address},'%') or status=#{status} ")
    public List<checkpoint> findBysele(RowBounds rowBounds,String name,String address,String status);
//
//    @Select("select*from cf_electric_checkpoint where name like concat('%',#{name},'%') or address like concat('%',#{address},'%') or status=#{status} ")
//    public List<checkpoint> findByLike(String name,String address,String status);
    @Select("select*from mes_project")
    List<project> findByproject();
    @Select("select*from mes_project")
    List<project> findByprojectpage(RowBounds rowBounds);

    List<project> findBylike(String name, String startDate, String endDate, String status);

    List<factory> findByfactory();public List<factory> findByfactory(String name);
    List<factory> findByfactory(RowBounds rowBounds);

    List<factory> findByload(Integer id);
    List<factory> equipment();

    List<factory> findwl(Integer id, String name, String model, String specification,String code);

    List <factory> w(String name);

    List<process> findByprocess(String name);

    List<process> findprocesspage(RowBounds rowBounds);
}
